﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$ArticleDBConnection$" >
	<Sql>
		INSERT INTO eComSalesOrders
		(id, seqNumber, discountCode, createdDate, lastItemChangeDate, statusId, paymentTermsId, companyId, userId)
		VALUES
		(@id, @seqNumber, @discountCode, GetDate(), @lastItemChangeDate, @statusId, @paymentTermsId, @companyId, @userId)
	</Sql>
	<Param name="id" type="UniqueIdentifier"/>
	<Param name="seqNumber" type="String"/>
	<Param name="discountCode" type="String"/>
	<Param name="customer.companyId" dbName="companyId"  type="UniqueIdentifier"/>
	<Param name="customer.id" dbName="userId" type="UniqueIdentifier"/>
	<Param name="status.id" dbName="statusId" type="UniqueIdentifier"/>
	<Param name="paymentMethod.id" dbName="paymentTermsId" type="UniqueIdentifier"/>
	<Param name="lastItemChangeDate" type="DateTime" />
</AdoNetDataAccess>